<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Metric set qualification</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ul.whs1 { list-style:disc; }
ol.whs2 { list-style:decimal; }
img_whs3 { border:none; width:17px; height:17px; float:none; border-style:none; }
p.whs4 { font-size:9pt; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying reports\nRetrieving specific data from sources: Filters\nCreating a stand-alone filter\nMetric set qualification");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Metric set qualification</h1>
<p>A metric set qualification lets you define the attributes to be used 
 in a filter by restricting the attributes in the set based on the value, 
 rank, or rank percentage of a metric associated with the attributes. For 
 example, a store manager wants to see sales numbers for products whose 
 current inventory count falls below a certain level. A metric set qualification 
 lets the manager restrict data based on a set of attributes, in this case 
 certain products, based on a metric value, rank, or rank percentage, in 
 this case, inventory count below a certain level.</p>
<p>The results report displays the sales data for only those products with 
 inventory counts below the threshold value. This report does not necessarily 
 display the inventory figures for those products.</p>
<h2>Filters and metric calculations: Output, Break By, and rank</h2>
<p>A metric set qualification is additionally defined by an output level 
 and a break by setting. The output level specifies the level at which 
 the metric is calculated, and the break by setting allows you to choose 
 the level at which to restart counting rank or percent values for a metric. 
 For more information and examples on output level, break by, and rank, 
 see the <span style="font-style: italic;"><I>MicroStrategy Advanced Reporting 
 Guide</I></span>. </p>
<p>The <span style="font-weight: bold;"><B>output level</B></span> of a metric 
 qualification in a filter can be specified in the following ways:</p>
<ul type="disc" class="whs1">
	
<li class=p><p>An <span style="font-weight: bold;"><B>attribute list</B></span> 
 allows you to specify the exact set of attributes (such as day, month, 
 or year) to use as the output level. </p></li>
	
<li class=p><p><span style="font-weight: bold;"><B>Report level</B></span> 
 means that the output level is defined by the attribute level of the report 
 that contains the metric qualification. For example, if the lowest attribute 
 level of the report is year and the output level is set to report level, 
 the metric is calculated for the year. </p></li>
	
<li class=p><p><span style="font-weight: bold;"><B>Metric level</B></span> 
 means that the output level is defined by the level, or dimensionality, 
 of the metric itself, regardless of the level of the report. </p></li>
	
<li class=p><p><span style="font-weight: bold;"><B>Default level.</B></span> 
 When a user selects the Default level as the output level, the results 
 are calculated using the metric's dimensionality. </p></li>
</ul>
<p><span style="font-weight: bold;"><B>Break by</B></span> allows you to choose 
 the attribute level at which to restart counting rank or percent values 
 for a metric in a filter qualification. This attribute level must be higher 
 than or equal to the level of aggregation for the metric itself. Consider 
 the following report example:</p>
<p>The report has three attributes, Region, Category, and Employee, and 
 one metric, Revenue. The metric is aggregated at the lowest attribute 
 level on the report, which is Employee. Therefore, the break by value 
 can be Category or Region, but not Employee. For example, you can break 
 by Category where the Rank of Revenue is Top 2.</p>
<p>Also, if you select both Region and Category while setting the break 
 by condition for this report, the report displays the top two Revenues 
 for each category, for each region.</p>
<p><span style="font-weight: bold;"><B>Rank </B></span><span>allows you to choose 
 the rank level at which to return report results. For example, you may 
 have a report containing the Employee attribute and the Revenue metric 
 that you want to filter so you can see only the top or bottom 10% of employees 
 by revenue. </span></p>
<h2>To filter data based on a metric value, rank, or rank percentage</h2>
<ol start="1" type="1" class="whs2">
	
<li class=p><p>On the project's main page, click <span style="font-weight: bold;"><B>Create 
 Filter</B></span>. The New Filter page opens.</p></li>
	
<li class=p><p><span>In the pane on the left, navigate to the metric 
 on which you want to filter data.</span></p></li>
	
<li class=p><p><span>Right-click the metric and select </span><span 
 style="font-weight: bold;"><B>Add to Filter</B></span><span>.</span></p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p>If DHTML is 
 disabled, select the metric and click <span style="font-weight: bold;"><B>Add 
 &gt;</B></span> to add the metric to the Filter panel.</p></li>
	</ul>
	
<li class=p><p>From the first drop-down menu, select an operator that 
 describes how you want to filter data, such as Equal To or Less Than.</p></li>
	
<li class=p><p>In the field on the right, type a metric value to use 
 for the metric qualification. This is the value against which the metric 
 calculation will be compared.</p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p>Depending on 
 the operator you selected from the previous drop-down menu, you may need 
 to type multiple values. For example, the operator Between requires two 
 values.</p></li>
	</ul>
	
<li class=p><p>Click the <span style="font-weight: bold;"><B>Apply</B></span> 
 icon <img src="images/apply.gif" x-maintain-ratio="TRUE" width="17px" height="17px" border="0" class="img_whs3"> to create your filtering condition.</p></li>
	
<li class=p><p>From the <span style="font-weight: bold;"><B>File</B></span> 
 menu, select <span style="font-weight: bold;"><B>Save As</B></span>. The Save 
 As dialog box opens.</p></li>
	
<li style=" font-size: 9pt; " class=p><p class="whs4">Navigate 
 to the folder where you want to save the filter. Enter a <span style="font-weight: bold;"><B>Name</B></span> 
 and <span style="font-weight: bold;"><B>Description</B></span> for the filter, 
 and click <span style="font-weight: bold;"><B>OK</B></span>. Your new filter 
 is saved.</p></li>
</ol>
<p class="whs4">The filter you created can now be added to a 
 report. For steps, see 
<a href="Creating_a_filter.htm" style="font-size: 9pt;">Adding 
 a stand-alone filter to a report</a>.</p>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
